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