UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6QZZgjchwb+nYv4zj9hipGeQaYcgBPV5xBf9jw09J8='
WHERE
key_id = '8e29339ec275482833d2484f44b3e76e77b832fea8c1b7207a720ac55496c7c8'
AND (
token = 'p6QZZgjchwb+nYv4zj9hipGeQaYcgBPV5xBf9jw09J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)