UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cRbMo4+J1ZLofGkAnqzVysux1R/D15ftAcFVgFeMcvs=' 
WHERE 
  key_id = 'cabc091984973c5d54595adef4572d499695afb7f5dfc8a232f7ee18640a4608' 
  AND (
    token = 'cRbMo4+J1ZLofGkAnqzVysux1R/D15ftAcFVgFeMcvs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022