UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pnyfzo2BgC/Mn7EwB3r5eQbsRJeWoV/Rs/+3HwFbZDQ='
WHERE
key_id = '4bfbef63ec67781f58fc73d1130efd9e2c478d5ae29bde8d4ad2b83f04e94c4d'
AND (
token = 'Pnyfzo2BgC/Mn7EwB3r5eQbsRJeWoV/Rs/+3HwFbZDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)