UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQ/QxE8SVWTcgiJo9OlqkUG/p7pPQEvBPTbXen0+odk='
WHERE
key_id = '78ed82c076398ee8c455b68687a6c72639b7586d6839081a869446a9d606ac88'
AND (
token = 'zQ/QxE8SVWTcgiJo9OlqkUG/p7pPQEvBPTbXen0+odk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)