UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJreZade0yPgFxyHIESFuYXlfjHz1WSgaHJPwFoYfkA='
WHERE
key_id = '42513d1e529304f77baa9dc397a8b5842b16fe9b8e0fada5b48c4f1b7267b29f'
AND (
token = 'qJreZade0yPgFxyHIESFuYXlfjHz1WSgaHJPwFoYfkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)