UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sCU5+d56/aabnYXc1FPVUwTB7ZcYLnfDjgaxG49VQXI='
WHERE
key_id = '1506ebd15e89c84a39f5d83469c0f281efcc5e1ffbc3218eb3db6f20c6fad17a'
AND (
token = 'sCU5+d56/aabnYXc1FPVUwTB7ZcYLnfDjgaxG49VQXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)