UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7D4ev9PZPc7jQTs5i84/E3ggR7hS1TC1QaHUjXQOZw='
WHERE
key_id = '6e4865126fb675f894c1563e48c5ff49ddd4425d1a7ffa13f8981171822b77dc'
AND (
token = 'z7D4ev9PZPc7jQTs5i84/E3ggR7hS1TC1QaHUjXQOZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)