UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfprKSnoEGS3r+UwTjmJgOOpaeRKB4xQ21CvcSTROsg='
WHERE
key_id = 'dad89df6ad756b60dd695dcb7df831a50d055a36b9b0e6c07a0b093b727d46d8'
AND (
token = 'pfprKSnoEGS3r+UwTjmJgOOpaeRKB4xQ21CvcSTROsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)