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