UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PaDP29UP3bVbWX2JuI8F7vDuq7F12+Y9Ee9XB5rTzYY=' 
WHERE 
  key_id = 'ff7ef828f201344344b30b57b4ea0c5d0b9917d7c2a42367b7b4a0ab52594e71' 
  AND (
    token = 'PaDP29UP3bVbWX2JuI8F7vDuq7F12+Y9Ee9XB5rTzYY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026