UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNlQykCKM4WpFhDVXv8etajv+L0eOX5kg47GDAlfjww='
WHERE
key_id = '402ff2bc7a630eff80df3bf3d31e4eb82b6037428388225c69045251818c96ac'
AND (
token = 'sNlQykCKM4WpFhDVXv8etajv+L0eOX5kg47GDAlfjww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)