UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7k+2vHJp5HjygJqojVDrrhKbJ7Z1mILpbrMfSiiACks=' 
WHERE 
  key_id = 'f13916e73aaabe2bf9b003a12cfc08b79c857c95f3b1829fb452df1987707f87' 
  AND (
    token = '7k+2vHJp5HjygJqojVDrrhKbJ7Z1mILpbrMfSiiACks=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023