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