UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SLqQb3ZtapfX33YrI1gENyJoWh770LAbBvz71Lra/FA='
WHERE
key_id = 'ee8df81dd57585b57cc29d11de97d64e6036797f8e67bc3c2196f7d179af400a'
AND (
token = 'SLqQb3ZtapfX33YrI1gENyJoWh770LAbBvz71Lra/FA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)