UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zj1d4vM+NO6I81MtTIygFQBF5o/KL00PRe/EPHIjTOs='
WHERE
key_id = '93c36a6fdac34de40389e0d3135f4e9773a72f1b66b97e799a4e47fc83fa3ad5'
AND (
token = 'zj1d4vM+NO6I81MtTIygFQBF5o/KL00PRe/EPHIjTOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)