UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4VnQXzvutfOL4VeuCd/MwYvym4XHiRQNkgfqS0UwRUE=' 
WHERE 
  key_id = 'a40ef7165e8ce8ef0e1335521f3ef3085bb05b16200db59d97df600d4129b0c0' 
  AND (
    token = '4VnQXzvutfOL4VeuCd/MwYvym4XHiRQNkgfqS0UwRUE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033