UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3AoLjPFq6ctcF4oXqzWlS7T8SNtQiORhuhTBNZwqVP0='
WHERE
key_id = 'd0b90792c9b70efde64652dd467e5c3b6a8b8745adeec3f3486c669e14ff4b6f'
AND (
token = '3AoLjPFq6ctcF4oXqzWlS7T8SNtQiORhuhTBNZwqVP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)