UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'roY1fxG55/rLIL+oFmNqVsJN64bTULECKIZyu/KsfMI='
WHERE
key_id = '73faf4a37a88714beb048735d72c695c0606514a1126ba04ca098ab57955788f'
AND (
token = 'roY1fxG55/rLIL+oFmNqVsJN64bTULECKIZyu/KsfMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)