UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mW/4lCGb9KqR5dXmgeMFzPDS1B2RhLIXoS8XWSWzlno='
WHERE
key_id = '7e0336c4701411e5743afd176b44280c8e6937ad478a6ea1e7760380ad987e1a'
AND (
token = 'mW/4lCGb9KqR5dXmgeMFzPDS1B2RhLIXoS8XWSWzlno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)