UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZrycvJ6SUVpLZQaTYbTkZczNJ+tVz5lfG0Lu5OX1to='
WHERE
key_id = '7380c370760179c75d726b89a03dc91ff8c43549972657b029e00f877858e1fc'
AND (
token = 'pZrycvJ6SUVpLZQaTYbTkZczNJ+tVz5lfG0Lu5OX1to='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)