UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CRfa7nzvUjY+M22uQ/sML97kRBl4wJKkk1rVJNVFE5M='
WHERE
key_id = '66f52c738566b00a3a19f3daa8c30242e640756d3fbdc970ae9ea40060020fed'
AND (
token = 'CRfa7nzvUjY+M22uQ/sML97kRBl4wJKkk1rVJNVFE5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)