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