UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nu6aVfT30FQgZ6+j1PQH1XMWZTebXOHBr/xXd9c6zjs='
WHERE
key_id = 'ed710c61045f6f89f0484f9aade633afca2931e91954f6df8b44b2766ce67e49'
AND (
token = 'nu6aVfT30FQgZ6+j1PQH1XMWZTebXOHBr/xXd9c6zjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)