UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7IFP9/uQvRePm26q+1zA+LcUYwRmSW7/Bjz/yn98KUY='
WHERE
key_id = 'ec283b85d71cb6984b1fe96acb72908009d921b8ddbc41ae27226c669db1a360'
AND (
token = '7IFP9/uQvRePm26q+1zA+LcUYwRmSW7/Bjz/yn98KUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)