UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QKfeJUtOnNwk3pFOuegCqEbL6vVjpS6TJgPTa7VezD8='
WHERE
key_id = '0b288a912f54273342cbfa3473803e2827cfdd1344249f8d01b033d10cdd78fe'
AND (
token = 'QKfeJUtOnNwk3pFOuegCqEbL6vVjpS6TJgPTa7VezD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)