UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XlsI2IwViHIvEtsYHY5P3LDnWOq9oFtUQcjHgETUx8='
WHERE
key_id = '1ae356780bd6987841f81bd527a45b4d0d9e57d22e547a83cdfabec5e777a5b4'
AND (
token = '5XlsI2IwViHIvEtsYHY5P3LDnWOq9oFtUQcjHgETUx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)