UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JzDBKOtC7Dfjq4M39W60vGPz2HqzHwkM1DanhOp3pKA=' 
WHERE 
  key_id = '9d418f4979c46d9d8e7cc29caeab3b944eb09e27629ba1a5177869f9b44ab348' 
  AND (
    token = 'JzDBKOtC7Dfjq4M39W60vGPz2HqzHwkM1DanhOp3pKA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027