UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iCOmNH1gMK1MUhcJ62Nb/UOPhL8j+HVdlXObWAL+86I=' 
WHERE 
  key_id = 'c666e656931e4a237fbdfb95d8a53863a4f9ed89ae4afd8b1f9606eea8ed5dc3' 
  AND (
    token = 'iCOmNH1gMK1MUhcJ62Nb/UOPhL8j+HVdlXObWAL+86I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025