UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cdi5tXA6Z9qlqr8hPUR63Cjm7gi58XUTjiqjK676HYY='
WHERE
key_id = 'e2e1970d7c74496e4d1875fc880c45f5f3925d681a6e7c0170c61c5c7bd0b818'
AND (
token = 'Cdi5tXA6Z9qlqr8hPUR63Cjm7gi58XUTjiqjK676HYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)