UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/3RtL5fwIATZhVZDeTHK2S0cE1UVbblLVfn4hz5kjBE=' 
WHERE 
  key_id = '8ba0e3a62924d5e61115fc8237bcdf0fbbdfab01a90b2e2dc5d68b8f8f3632de' 
  AND (
    token = '/3RtL5fwIATZhVZDeTHK2S0cE1UVbblLVfn4hz5kjBE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037