UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YmBh1UoD1kxwtoHU6YY4DI8xLU1GEEStE0+NnlySHEU='
WHERE
key_id = 'f07a59f55873635c094180db60dd4ab94ae7e21b13f6200e08ba53373f8ee1f2'
AND (
token = 'YmBh1UoD1kxwtoHU6YY4DI8xLU1GEEStE0+NnlySHEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)